/****** Object:  Table [dbo].[Invoice_Freight]    Script Date: 01/28/2021 16:21:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_Freight](
	[Inv_FreightID] [bigint] IDENTITY(1,1) NOT NULL,
	[Inv_FreightDate] [datetime] NOT NULL,
	[Inv_FreightVNo] [varchar](16) NOT NULL,
	[SessionID] [smallint] NOT NULL,
	[Remarks] [varchar](150) NULL,
	[ReadOnly] [bit] NOT NULL CONSTRAINT [DF_Invoice_Freight_ReadOnly]  DEFAULT ((0)),
	[LoginID] [int] NOT NULL,
	[HostName] [varchar](50) NULL CONSTRAINT [DF_Invoice_Freight_HostName]  DEFAULT (host_name()),
	[EntryDateTime] [datetime] NULL CONSTRAINT [DF_Invoice_Freight_EntryDateTime]  DEFAULT (getdate()),
	[ModifyID] [int] NULL,
	[ModifyHostName] [varchar](50) NULL,
	[ModifyDateTime] [datetime] NULL,
	[BEDate] [datetime] NULL,
	[BENo] [varchar](50) NULL,
	[Currency] [varchar](50) NOT NULL,
	[ContainerNo] [varchar](200) NULL,
	[NoOfContainers] [numeric](15, 0) NOT NULL CONSTRAINT [DF_Invoice_Freight_NoOfContainers]  DEFAULT ((0)),
	[SumQTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Freight_SumQTY]  DEFAULT ((0)),
	[SumAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Freight_SumAmount]  DEFAULT ((0)),
	[SumExRate] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Freight_SumExRate]  DEFAULT ((0)),
	[SumNetAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Freight_NetAmount]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_Freight] PRIMARY KEY CLUSTERED 
(
	[Inv_FreightID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_FreightDetail]    Script Date: 01/28/2021 16:21:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_FreightDetail](
	[inv_FreightDetailID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_FreightID] [bigint] NOT NULL,
	[AgentID] [int] NULL,
	[DTypeID] [int] NULL,
	[QTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_FreightDetail_QTY]  DEFAULT ((0)),
	[Amount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_FreightDetail_Amount]  DEFAULT ((0)),
	[ExRate] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_FreightDetail_ExRate]  DEFAULT ((0)),
	[NetAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_FreightDetail_NetAmount]  DEFAULT ((0)),
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_FreightDetail_Type]  DEFAULT ((0)),
	[SaleDate] [datetime] NULL,
	[Remarks] [varchar](100) NULL,
 CONSTRAINT [PK_Invoice_FreightDetail] PRIMARY KEY CLUSTERED 
(
	[inv_FreightDetailID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF